package com.ticket.system.service.impl;

import com.alibaba.fastjson2.JSONObject;
import com.ticket.common.annotation.DataScope;
import com.ticket.common.constant.Constants;
import com.ticket.common.constant.UserConstants;
import com.ticket.common.core.domain.entity.SysRole;
import com.ticket.common.core.domain.entity.SysUser;
import com.ticket.common.core.redis.RedisCache;
import com.ticket.common.exception.ServiceException;
import com.ticket.common.exception.base.BaseException;
import com.ticket.common.exception.user.CaptchaException;
import com.ticket.common.exception.user.CaptchaExpireException;
import com.ticket.common.utils.DateUtils;
import com.ticket.common.utils.SecurityUtils;
import com.ticket.common.utils.StringUtils;
import com.ticket.common.utils.bean.BeanValidators;
import com.ticket.common.utils.spring.SpringUtils;
import com.ticket.system.domain.SysPost;
import com.ticket.system.domain.SysUserPost;
import com.ticket.system.domain.SysUserRole;
import com.ticket.system.domain.YanchuScoreDetail;
import com.ticket.system.domain.vo.CardUserInfoVO;
import com.ticket.system.domain.vo.ForgetPasswordVO;
import com.ticket.system.domain.vo.WxLoginBody;
import com.ticket.system.mapper.*;
import com.ticket.system.service.ISysConfigService;
import com.ticket.system.service.ISysUserService;
import com.ticket.system.service.ITYanchuPointsRuleService;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.util.CollectionUtils;

import javax.validation.Validator;
import java.util.ArrayList;
import java.util.List;
import java.util.stream.Collectors;

/**
 * 用户 业务层处理
 * 
 * @author ruoyi
 */
@Service
public class SysUserServiceImpl implements ISysUserService
{
    private static final Logger log = LoggerFactory.getLogger(SysUserServiceImpl.class);
    private static final String ONEOPERA = "集团管理员";
    private static final String TWOOPERA = "剧院管理员";
    private static final String MEMBER = "剧院成员";

    private String OPENID = "https://api.weixin.qq.com/sns/oauth2/access_token?appid=APPID&secret=SECRET&code=CODE&grant_type=authorization_code";
    private String UNIONID = "https://api.weixin.qq.com/sns/userinfo?access_token=ACCESS_TOKEN&openid=OPENID&lang=zh_CN";
    private String APPLET_PHONE = "https://api.weixin.qq.com/wxa/business/getuserphonenumber?access_token=ACCESS_TOKEN";
    private String APPLET_LOGIN = "https://api.weixin.qq.com/sns/jscode2session?appid=APPID&secret=SECRET&js_code=JSCODE&grant_type=authorization_code";


    @Autowired
    private SysUserMapper userMapper;

    @Autowired
    private SysRoleMapper roleMapper;

    @Autowired
    private SysPostMapper postMapper;

    @Autowired
    private SysUserRoleMapper userRoleMapper;

    @Autowired
    private SysUserPostMapper userPostMapper;

    @Autowired
    private ISysConfigService configService;

    @Autowired
    protected Validator validator;

    @Autowired
    private RedisCache redisCache;
    @Autowired
    private ITYanchuPointsRuleService yanchuPointsRuleService;

    @Autowired
    private YanchuScoreDetailMapper yanchuScoreDetailMapper;

    /**
     * 根据条件分页查询用户列表
     * 
     * @param user 用户信息
     * @return 用户信息集合信息
     */
    @Override
    @DataScope(deptAlias = "d", userAlias = "u")
    public List<SysUser> selectUserList(SysUser user)
    {
        return userMapper.selectUserList(user);
    }

    /**
     * 根据条件分页查询已分配用户角色列表
     * 
     * @param user 用户信息
     * @return 用户信息集合信息
     */
    @Override
    @DataScope(deptAlias = "d", userAlias = "u")
    public List<SysUser> selectAllocatedList(SysUser user)
    {
        return userMapper.selectAllocatedList(user);
    }

    /**
     * 根据条件分页查询未分配用户角色列表
     * 
     * @param user 用户信息
     * @return 用户信息集合信息
     */
    @Override
    @DataScope(deptAlias = "d", userAlias = "u")
    public List<SysUser> selectUnallocatedList(SysUser user)
    {
        return userMapper.selectUnallocatedList(user);
    }

    /**
     * 通过用户名查询用户
     * 
     * @param userName 用户名
     * @return 用户对象信息
     */
    @Override
    public SysUser selectUserByUserName(String userName)
    {
        return userMapper.selectUserByUserName(userName);
    }

    /**
     * 通过用户ID查询用户
     * 
     * @param userId 用户ID
     * @return 用户对象信息
     */
    @Override
    public SysUser selectUserById(Long userId)
    {
        return userMapper.selectUserById(userId);
    }

    /**
     * 查询用户所属角色组
     * 
     * @param userName 用户名
     * @return 结果
     */
    @Override
    public String selectUserRoleGroup(String userName)
    {
        List<SysRole> list = roleMapper.selectRolesByUserName(userName);
        if (CollectionUtils.isEmpty(list))
        {
            return StringUtils.EMPTY;
        }
        return list.stream().map(SysRole::getRoleName).collect(Collectors.joining(","));
    }

    /**
     * 查询用户所属岗位组
     * 
     * @param userName 用户名
     * @return 结果
     */
    @Override
    public String selectUserPostGroup(String userName)
    {
        List<SysPost> list = postMapper.selectPostsByUserName(userName);
        if (CollectionUtils.isEmpty(list))
        {
            return StringUtils.EMPTY;
        }
        return list.stream().map(SysPost::getPostName).collect(Collectors.joining(","));
    }

    /**
     * 校验用户名称是否唯一
     * 
     * @param user 用户信息
     * @return 结果
     */
    @Override
    public boolean checkUserNameUnique(SysUser user)
    {
        Long userId = StringUtils.isNull(user.getUserId()) ? -1L : user.getUserId();
        SysUser info = userMapper.checkUserNameUnique(user.getUserName());
        if (StringUtils.isNotNull(info) && info.getUserId().longValue() != userId.longValue())
        {
            return UserConstants.NOT_UNIQUE;
        }
        return UserConstants.UNIQUE;
    }

    /**
     * 校验手机号码是否唯一
     *
     * @param user 用户信息
     * @return
     */
    @Override
    public boolean checkPhoneUnique(SysUser user)
    {
        Long userId = StringUtils.isNull(user.getUserId()) ? -1L : user.getUserId();
        SysUser info = userMapper.checkPhoneUnique(user.getPhonenumber());
        if (StringUtils.isNotNull(info) && info.getUserId().longValue() != userId.longValue())
        {
            return UserConstants.NOT_UNIQUE;
        }
        return UserConstants.UNIQUE;
    }

    /**
     * 校验email是否唯一
     *
     * @param user 用户信息
     * @return
     */
    @Override
    public boolean checkEmailUnique(SysUser user)
    {
        Long userId = StringUtils.isNull(user.getUserId()) ? -1L : user.getUserId();
        SysUser info = userMapper.checkEmailUnique(user.getEmail());
        if (StringUtils.isNotNull(info) && info.getUserId().longValue() != userId.longValue())
        {
            return UserConstants.NOT_UNIQUE;
        }
        return UserConstants.UNIQUE;
    }

    /**
     * 校验用户是否允许操作
     * 
     * @param user 用户信息
     */
    @Override
    public void checkUserAllowed(SysUser user)
    {
        if (StringUtils.isNotNull(user.getUserId()) && user.isAdmin())
        {
            throw new ServiceException("不允许操作超级管理员用户");
        }
    }

    /**
     * 校验用户是否有数据权限
     * 
     * @param userId 用户id
     */
    @Override
    public void checkUserDataScope(Long userId)
    {
        if (!SysUser.isAdmin(SecurityUtils.getUserId()))
        {
            SysUser user = new SysUser();
            user.setUserId(userId);
            List<SysUser> users = SpringUtils.getAopProxy(this).selectUserList(user);
            if (StringUtils.isEmpty(users))
            {
                throw new ServiceException("没有权限访问用户数据！");
            }
        }
    }

    /**
     * 新增保存用户信息
     * 
     * @param user 用户信息
     * @return 结果
     */
    @Override
    @Transactional
    public int insertUser(SysUser user)
    {
        if (StringUtils.isNull(user.getDeptId())){
            user.setDeptId(user.getOperaId());
        }
        if (StringUtils.isEmpty(user.getRoleIds())){
            List<SysRole> roleIdBy = roleMapper.getRoleIdBy(MEMBER, 99);
            Long [] role = new Long[]{roleIdBy.get(0).getRoleId()};
            user.setRoleIds(role);
            user.setUserType("03");
        }else {
            List<SysRole> sysRoles = roleMapper.selectRoleByIds(user.getRoleIds());
            if (CollectionUtils.isEmpty(sysRoles)){
                throw new BaseException("角色不存在");
            }
            List<String> sysNames = sysRoles.stream().map(SysRole::getRoleName).collect(Collectors.toList());
            if (sysNames.contains(ONEOPERA) || sysNames.contains(TWOOPERA)){
                user.setUserType("02");
            }else {
                user.setUserType("03");
            }
        }
        // 新增用户信息
        int rows = userMapper.insertUser(user);
        // 新增用户岗位关联
        insertUserPost(user);
        // 新增用户与角色管理
        insertUserRole(user);
        return rows;
    }

    /**
     * 注册用户信息
     * 
     * @param user 用户信息
     * @return 结果
     */
    @Override
    public boolean registerUser(SysUser user)
    {
        return userMapper.insertUser(user) > 0;
    }

    /**
     * 修改保存用户信息
     * 
     * @param user 用户信息
     * @return 结果
     */
    @Override
    @Transactional
    public int updateUser(SysUser user)
    {
        if (StringUtils.isNull(user.getDeptId())){
            user.setDeptId(user.getOperaId());
        }
        if (StringUtils.isEmpty(user.getRoleIds())){
            List<SysRole> roleIdBy = roleMapper.getRoleIdBy(MEMBER, 99);
            Long [] role = new Long[]{roleIdBy.get(0).getRoleId()};
            user.setRoleIds(role);user.setUserType("03");
        }else {
            List<SysRole> sysRoles = roleMapper.selectRoleByIds(user.getRoleIds());
            if (CollectionUtils.isEmpty(sysRoles)){
                throw new BaseException("角色不存在");
            }
            List<String> sysNames = sysRoles.stream().map(SysRole::getRoleName).collect(Collectors.toList());
            if (sysNames.contains(ONEOPERA) || sysNames.contains(TWOOPERA)){
                user.setUserType("02");
            }else {
                user.setUserType("03");
            }
        }
        Long userId = user.getUserId();
        // 删除用户与角色关联
        userRoleMapper.deleteUserRoleByUserId(userId);
        // 新增用户与角色管理
        insertUserRole(user);
        // 删除用户与岗位关联
        userPostMapper.deleteUserPostByUserId(userId);
        // 新增用户与岗位管理
        insertUserPost(user);
        return userMapper.updateUser(user);
    }

    /**
     * 用户授权角色
     * 
     * @param userId 用户ID
     * @param roleIds 角色组
     */
    @Override
    @Transactional
    public void insertUserAuth(Long userId, Long[] roleIds)
    {
        userRoleMapper.deleteUserRoleByUserId(userId);
        insertUserRole(userId, roleIds);
    }

    /**
     * 修改用户状态
     * 
     * @param user 用户信息
     * @return 结果
     */
    @Override
    public int updateUserStatus(SysUser user)
    {
        return userMapper.updateUser(user);
    }

    /**
     * 修改用户基本信息
     * 
     * @param user 用户信息
     * @return 结果
     */
    @Override
    public int updateUserProfile(SysUser user)
    {
        int count = userMapper.updateUser(user);
        if(StringUtils.isNotEmpty(user.getOpenId())){
            userMapper.clearUserByOpenId(user);
            YanchuScoreDetail yanchuScoreDetail = new YanchuScoreDetail();
            yanchuScoreDetail.setPointsRuleId(6l);
            yanchuScoreDetail.setUserId(user.getUserId());
            List<YanchuScoreDetail> list = yanchuScoreDetailMapper.selectYanchuScoreDetailList(yanchuScoreDetail);
            if(CollectionUtils.isEmpty(list)){
                //完善个人信息
                yanchuPointsRuleService.addPoints(6,null,user.getUserId());
            }
        }
        return count;
    }

    /**
     * 修改用户头像
     * 
     * @param userName 用户名
     * @param avatar 头像地址
     * @return 结果
     */
    @Override
    public boolean updateUserAvatar(String userName, String avatar)
    {
        return userMapper.updateUserAvatar(userName, avatar) > 0;
    }

    /**
     * 重置用户密码
     * 
     * @param user 用户信息
     * @return 结果
     */
    @Override
    public int resetPwd(SysUser user)
    {
        return userMapper.updateUser(user);
    }

    /**
     * 重置用户密码
     * 
     * @param userName 用户名
     * @param password 密码
     * @return 结果
     */
    @Override
    public int resetUserPwd(String userName, String password)
    {
        return userMapper.resetUserPwd(userName, password);
    }

    /**
     * 新增用户角色信息
     * 
     * @param user 用户对象
     */
    public void insertUserRole(SysUser user)
    {
        this.insertUserRole(user.getUserId(), user.getRoleIds());
    }

    /**
     * 新增用户岗位信息
     * 
     * @param user 用户对象
     */
    public void insertUserPost(SysUser user)
    {
        Long[] posts = user.getPostIds();
        if (StringUtils.isNotEmpty(posts))
        {
            // 新增用户与岗位管理
            List<SysUserPost> list = new ArrayList<SysUserPost>(posts.length);
            for (Long postId : posts)
            {
                SysUserPost up = new SysUserPost();
                up.setUserId(user.getUserId());
                up.setPostId(postId);
                list.add(up);
            }
            userPostMapper.batchUserPost(list);
        }
    }

    /**
     * 新增用户角色信息
     * 
     * @param userId 用户ID
     * @param roleIds 角色组
     */
    public void insertUserRole(Long userId, Long[] roleIds)
    {
        if (StringUtils.isNotEmpty(roleIds))
        {
            // 新增用户与角色管理
            List<SysUserRole> list = new ArrayList<SysUserRole>(roleIds.length);
            for (Long roleId : roleIds)
            {
                SysUserRole ur = new SysUserRole();
                ur.setUserId(userId);
                ur.setRoleId(roleId);
                list.add(ur);
            }
            userRoleMapper.batchUserRole(list);
        }
    }

    /**
     * 通过用户ID删除用户
     * 
     * @param userId 用户ID
     * @return 结果
     */
    @Override
    @Transactional
    public int deleteUserById(Long userId)
    {
        // 删除用户与角色关联
        userRoleMapper.deleteUserRoleByUserId(userId);
        // 删除用户与岗位表
        userPostMapper.deleteUserPostByUserId(userId);
        return userMapper.deleteUserById(userId);
    }

    /**
     * 批量删除用户信息
     * 
     * @param userIds 需要删除的用户ID
     * @return 结果
     */
    @Override
    @Transactional
    public int deleteUserByIds(Long[] userIds)
    {
        for (Long userId : userIds)
        {
            checkUserAllowed(new SysUser(userId));
            checkUserDataScope(userId);
        }
        // 删除用户与角色关联
        userRoleMapper.deleteUserRole(userIds);
        // 删除用户与岗位关联
        userPostMapper.deleteUserPost(userIds);
        return userMapper.deleteUserByIds(userIds);
    }

    /**
     * 导入用户数据
     * 
     * @param userList 用户数据列表
     * @param isUpdateSupport 是否更新支持，如果已存在，则进行更新数据
     * @param operName 操作用户
     * @return 结果
     */
    @Override
    public String importUser(List<SysUser> userList, Boolean isUpdateSupport, String operName,Long userId)
    {
        if (StringUtils.isNull(userList) || userList.size() == 0)
        {
            throw new ServiceException("导入用户数据不能为空！");
        }
        int successNum = 0;
        int failureNum = 0;
        StringBuilder successMsg = new StringBuilder();
        StringBuilder failureMsg = new StringBuilder();
        String password = configService.selectConfigByKey("sys.user.initPassword");
        SysUser sysUser = userMapper.selectUserById(userId);
        if (StringUtils.isNull(sysUser.getOperaId())){
            throw new BaseException("当前登录人不存在某个剧院内");
        }
        for (SysUser user : userList)
        {
            user.setOperaId(sysUser.getOperaId());
            try
            {
                // 验证是否存在这个用户
                SysUser u = userMapper.selectUserByUserName(user.getUserName());
                if (StringUtils.isNull(u))
                {
                    BeanValidators.validateWithException(validator, user);
                    user.setPassword(SecurityUtils.encryptPassword(password));
                    user.setCreateBy(operName);
                    this.insertUser(user);
                    successNum++;
                    successMsg.append("<br/>" + successNum + "、账号 " + user.getUserName() + " 导入成功");
                }
                else if (isUpdateSupport)
                {
                    BeanValidators.validateWithException(validator, user);
                    checkUserAllowed(user);
                    checkUserDataScope(user.getUserId());
                    user.setUpdateBy(operName);
                    this.updateUser(user);
                    successNum++;
                    successMsg.append("<br/>" + successNum + "、账号 " + user.getUserName() + " 更新成功");
                }
                else
                {
                    failureNum++;
                    failureMsg.append("<br/>" + failureNum + "、账号 " + user.getUserName() + " 已存在");
                }
            }
            catch (Exception e)
            {
                failureNum++;
                String msg = "<br/>" + failureNum + "、账号 " + user.getUserName() + " 导入失败：";
                failureMsg.append(msg + e.getMessage());
                log.error(msg, e);
            }
        }
        if (failureNum > 0)
        {
            failureMsg.insert(0, "很抱歉，导入失败！共 " + failureNum + " 条数据格式不正确，错误如下：");
            throw new ServiceException(failureMsg.toString());
        }
        else
        {
            successMsg.insert(0, "恭喜您，数据已全部导入成功！共 " + successNum + " 条，数据如下：");
        }
        return successMsg.toString();
    }

    @Override
    public SysUser wxLogin(WxLoginBody wxLoginBody){
        SysUser user = new SysUser();
        // 新增
        user.setAvatar(wxLoginBody.getAvatar());
        //            wxUser.setUnionId(unionid);
        user.setOpenId(wxLoginBody.getOpenId());
        user.setCreateTime(DateUtils.getNowDate());
        user.setUpdateTime(DateUtils.getNowDate());
        if(StringUtils.isNotEmpty(wxLoginBody.getPhone())){
            user.setPhonenumber(wxLoginBody.getPhone());
            user.setUserName(wxLoginBody.getPhone());
            user.setNickName(wxLoginBody.getPhone());
        }
        user.setDelFlag(UserConstants.NORMAL);
        user.setUserType(UserConstants.USER_TYPE_WECHAT);
        user.setAppId(wxLoginBody.getAppId());
        user.setStatus(UserConstants.NORMAL);
        //新增 用户
        userMapper.insertUser(user);
        yanchuPointsRuleService.addPoints(1,null,user.getUserId());
        return user;
    }

    @Override
    public SysUser selectUserByOpenId(String eduOpenId,String userType,String appid){
        return userMapper.selectUserByOpenId(eduOpenId,userType,appid);
    }

    @Override
    public SysUser selectUserByPhonenumberAndType(String phone,String userType){
        return userMapper.selectUserByPhoneAndType(phone,userType);
    }
    @Override
    public JSONObject getWxAppletPhone(String code, String openId){
//        if (org.apache.commons.lang3.StringUtils.isEmpty(code)) {
//            throw new ServiceException("code can not be null");
//        }
//        if (org.apache.commons.lang3.StringUtils.isEmpty(openId)) {
//            throw new ServiceException("openId can not be null");
//        }
//        //获取access_token
//        String accessToken = WeixinUtil.getAccessToken(WxMaConfigHolder.get(), "7095410fbfe78ae965666d8ce9b17421", false);
//        String phoneUrl = APPLET_PHONE.replace("ACCESS_TOKEN", accessToken);
//        StringBuffer sb = new StringBuffer();
//        sb.append("{");
//        sb.append("\"code\":\""+code+"\"");
//        sb.append("}");
//        JSONObject post = HttpsRequestUtils.post(phoneUrl, sb.toString());
//        log.info("向微信换取用户手机号信息返回：" + post.toJSONString());
//        Integer errcode = post.getInteger("errcode");
//        JSONObject phoneInfo = post.getJSONObject("phone_info");
//        if (phoneInfo == null) {
//            throw new ServiceException("获取微信手机号失败errCode：" + errcode);
//        }
//        String phoneNumber = phoneInfo.getString("phoneNumber");
//        if (org.apache.commons.lang3.StringUtils.isEmpty(phoneNumber)) {
//            throw new ServiceException("获取微信手机号失败");
//        }
//        //根据手机号查询
//        SysUser salaUser = selectUserByPhonenumberAndType(phoneNumber,null);
//        if (salaUser != null) {
//            SalaUser salaUser1 = salaUserService.selectSalaUserAppletOpenId(openId);
//            if (salaUser1 != null && !phoneNumber.equals(salaUser1.getPhone())) {
//                throw new BusinessException("当前微信用户已关联其他手机号");
//            }
//            //判断当前手机号是否有当前小程序openid
//            if (org.apache.commons.lang3.StringUtils.isEmpty(salaUser.getWxAppletOpenid())) {
//                salaUser.setWxAppletOpenid(openId);
//                salaUserService.updateWxAppletOpenId(salaUser);
//            } else {
//                if (!salaUser.getWxAppletOpenid().equals(openId)) {
//                    //判断该账户的openid是否是当前用户openid，如果不是则更新
//                    salaUser.setWxAppletOpenid(openId);
//                    salaUserService.updateWxAppletOpenId(salaUser);
//                }
//            }
//        } else {
//            //注册
//            salaUser = salaUserService.wxAppletRegist(phoneNumber,openId);
//        }
//        String token = salaUserService.getToken(salaUser);
//        post.put("token",token);
//        return post;
        return null;
    }

    @Override
    public int forgetPassword(ForgetPasswordVO forgetPasswordVO) {
        //校验验证码是否正确
        String redisKey = Constants.SMSCODE_CODE_KEY + forgetPasswordVO.getPhone();
        String cacheObject = redisCache.getCacheObject(redisKey);
        if (org.apache.commons.lang3.StringUtils.isEmpty(cacheObject)) {
            //验证码失效
            throw new CaptchaExpireException();
        }
        if (!org.apache.commons.lang3.StringUtils.equals(cacheObject, forgetPasswordVO.getCode())) {
            // 验证码输入错误
            throw new CaptchaException();
        }
        log.info("====>验证成功!<=====");
        int count = 0;
        // 验证码正确, 删除之前的验证码
        redisCache.deleteObject(redisKey);
        SysUser sysUser = userMapper.selectUserByPhoneAndType(forgetPasswordVO.getPhone(),null);
        if (null != sysUser) {
            SysUser sysUserUp = new SysUser();
            sysUserUp.setUserId(sysUser.getUserId());
            sysUserUp.setPassword(SecurityUtils.encryptPassword(forgetPasswordVO.getPassword()));
            count = userMapper.updateUser(sysUserUp);
        } else {
            throw new ServiceException("该账号不存在!");
        }
        return count;
    }

    @Override
    public int clearUserOpenId(String openId){
        log.info("clearUserOpenId openId:{}",openId);
        return userMapper.clearUserOpenId(openId);
    }

    @Override
    public List<CardUserInfoVO> getUserNameByIds(List<Long> creatIds) {
        return userMapper.getUserNameByIds(creatIds);
    }
}
